using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Reflection;
using JUtil;
using JUtil.Extensions;
using JUtil.Web;
using JUtil.ResourceManagement;
using System.Data;

namespace TPPDDB.FestivalTicketSystem
{
	[DataObject(true)]
	public class BLL_FESTIVAL_ACTIVITY : BLL<FESTIVAL_ACTIVITY>
	{
		#region GetOrderBy
		protected override string GetOrderBy()
		{
			return SqlFile.GetSQL("GetOrderBy");
		}
		#endregion

		#region GetSelectSQLNoOrderBy
		protected override string GetSelectSQLNoOrderBy(Hashtable Parameters)
		{
			string sql = SqlFile.GetSQL("GetSelectSQLNoOrderBy");
			return sql;
		}
		#endregion

		#region GetSelectDetailsVwSQL
		protected override string GetSelectDetailsVwSQL(Hashtable Parameters)
		{
			throw new NotImplementedException();

			string sql = SqlFile.GetSQL("GetSelectDetailsVwSQL");
			return sql;
		}
		#endregion

		#region GetInsertSQL
		public override List<string> GetInsertSQL(FESTIVAL_ACTIVITY aRec)
		{
			throw new NotImplementedException();

			List<string> lst = new List<string>();
			string sql = SqlFile.GetSQL("GetInsertSQL");
			lst.Add(sql);
			return lst;
		}
		#endregion

		#region GetUpdateSQL
		public override List<string> GetUpdateSQL(FESTIVAL_ACTIVITY aRec)
		{
			throw new NotImplementedException();

			List<string> lst = new List<string>();
			string sql = SqlFile.GetSQL("GetUpdateSQL");
			lst.Add(sql);
			return lst;
		}
		#endregion

		#region GetDeleteSQL
		public override List<string> GetDeleteSQL(FESTIVAL_ACTIVITY aRec)
		{
			throw new NotImplementedException();

			List<string> lst = new List<string>();
			string sql = SqlFile.GetSQL("GetDeleteSQL");
			lst.Add(sql);
			return lst;
		}
		#endregion

		#region CreateDbObject
		protected override IDatabase CreateDbObject()
		{
			IDatabase database = new Database(DatabaseMode.Oracle, "Data Source=tppddb;User ID=tpdbuser;Password=tpdbuser;");
			return database;
		}
		#endregion

	}
}
